I have a website running on a windows hosting package with my provider. I bought a new windows hosting package, and now i want to copy my 'older' site into the new pack.
SO I can acces the old db and the new db (which is still totaly empty, no tables, ..) through sql server. So they both connect to an online server, it's not local.
Now I want to copy old db to new. First option is to use: tasks > copy database In this wizard i enter my source db data, next, i enter my destination db data, next, now i get the message 'copy database wizard - object reference not set to an instance of an object'. So here i get stuck..
Alternative option I think is to export old db, and later import into new. So i go to: tasks > backup I select my old db, full backup type, destination: disk --> i'm not sure what 'disk' means. Does it mean create a backup file on my local disk on my laptop from where i do all of this? --> The standard value that is there looks like an url to a server though, it starts with an ip adress: \172.20.101.253\sql008\TRN\ID97655_..............tm --> since i do not know how to access that place, i remove it and i add a new path, something like: D:\MSSQL\BACKUP\backuptest.Bak --> that .bak file does not exist yet there, the path does exist --> then i get the warning: 'cannot verify the existence of the backup file location. do you want to use the backup file location anyway?' --> i choose 'yes', then the backup completes succesfully to 100% --> there is no bak file to be found on that directory. so now i'm stuck here to
for the disk location i entered, is it still searching that location on the server instead of localy? when i google for this issue i find a lot of threads saying it's some rights issue. So I go to my D drive, richtclick , properties, security. Here I find 4 standard users (verified users, SYSTEM, administrators, users), i make sure all of them have all access. But maybe this is not enough? do i need to create a new user? how do i know which one?
Thanks for helping me further with this, have a nice day,